[bug report/problem]

--Boundary_(ID_E4gHDCXP54m6htKWgMeAbA)
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7BIT

[] ERROR 1104: The SELECT would examine too many records and probably
take a very long time. Check your WHERE and use SET OPTION
SQL_BIG_SELECTS=1 if the SELECT is ok



MySQL Control Center 0.9.1 beta returns this error for any SELECT query
in a table with more than 1 record (SELECT * FROM table). The table in
question only has 2 records across 5 columns, all INT entries.

Submitting queries through the command line does not give an error.
Setting the option SQL_BIG_SELECTS=1 both in the query itself and in the
query options still produces this error.


--Boundary_(ID_E4gHDCXP54m6htKWgMeAbA)--
Ark [ Do, 01 Mai 2003 06:30 ] [ ID #67740 ]
Datenbanken » gmane.comp.db.mysql.bugs » [bug report/problem]

Vorheriges Thema: possible problem with UNION and LEFT JOIN
Nächstes Thema: different DISTINCT ordering with InnoDB and MyISAM